<?php
//       PHPcongrats - Holiday and Birthday Mailer
//     
//    Copyright (C) 2011  Matthias Nass
//
//    This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.
//
//    This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
//
//    You should have received a copy of the GNU General Public License along with this program; if not, see <http://www.gnu.org/licenses/>.
session_start();

if ($_SESSION['loggedin'] == true){
        $id =  (int) $_GET['id'];
        include 'DBconnect.php';
        include 'datefunction.php';
        $query = "SELECT * FROM holidays WHERE id=".$id.";";
        $result = mysql_db_query($database, $query, $link);
        $row = mysql_fetch_row($result);
        mysql_close($link);
     	?>
     <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
     <html>
     <head>
     <title>Feiertag &auml;ndern</title>
     <link rel="stylesheet" type="text/css" href="./styles.css">
     </head>
     <body>
     	<h2>PHPcongrats <img src='./icons/rosette.png' alt='Rosette'/></h2>
     	<h1>Feiertag &auml;ndern<img src='./icons/date_edit.png' alt='edit holiday'/></h1>
     	<p class="message">
     	<?php if($_SESSION['message'] == ''){}else{?>
     	<img src='./icons/error.png' alt='attention'/> <?php echo $_SESSION['message']; }?>
     	</p>
     	<p>
     	<form action="./actionchaholiday.php" method="post">
     		<input type="hidden" name="id" value="<?php echo $row[0] ?>">
     		<input type="text" name="name" value=<?php echo $row[1]?>> Name<br>
     		<select name="day">
     		<?php for($i=1;$i<32;$i++){
     		if(date_mysql2day($row[2])==$i)
     		     {echo "<option value='".$i."' selected>".$i."</option>";}
     		else     
     		     {echo "<option value='".$i."'>".$i."</option>";}
             }?>
     		</select>
     		<select name="month">
     		<?php for($i=1;$i<13;$i++){
     		if(date_mysql2month($row[2])==$i)
     		     {echo "<option value='".$i."' selected>".$i."</option>";}
     		else 
     		     {echo "<option value='".$i."'>".$i."</option>";}
             }?>
             </select>	
     		<select name="year">
     		<?php for($i=2011;$i<2100;$i++){
     		if(date_mysql2year($row[2])==$i)
     		     {echo "<option value='".$i."' selected>".$i."</option>";}
     		else 
     		     {echo "<option value='".$i."'>".$i."</option>";}
             }?>
     		</select>
     		<?php if ($row[3]==1)
     		     {echo "<input type='checkbox' name='revising' checked>";}
     		else 
     		     {echo "<input type='checkbox' name='revising'>";}?>
     		 Wiederholend ja/nein<br>
     		 <input type="text" name="region" value=<?php echo $row[4]?>> Region<br>
     		 <input type="text" name="country" value=<?php echo $row[5]?>> Land<br>
     		<input type="submit" name="submit"><br>
     	</form>
     	<p>
     		<a href="./holidays.php"><img src='./icons/cross.png' alt='Cancel'/> Abbrechen</a>
     	</p>
     </body>
     </html>
     	<?php
     	$_SESSION['message'] = "";
}
else{
    $_SESSION['last_location'] = "./holidayscha.php";
	header( 'Location: http:./login.php' );
}
?>